/*=====================================================================
  This file is part of a Microsoft SQL Server Shared Source Application.
  Copyright (C) Microsoft Corporation.  All rights reserved.
 
THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY
KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
PARTICULAR PURPOSE.
======================================================= */
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2002-07-18' and ModifiedDate < '2002-10-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2002-10-18' and ModifiedDate < '2002-12-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2002-12-18' and ModifiedDate < '2003-02-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2003-02-18' and ModifiedDate < '2003-05-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2003-05-18' and ModifiedDate < '2003-08-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2003-08-18' and ModifiedDate < '2003-10-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2003-10-18' and ModifiedDate < '2003-12-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2003-12-18' and ModifiedDate < '2004-03-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2004-03-18' and ModifiedDate < '2004-05-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2004-05-18' and ModifiedDate < '2004-07-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
-- Generate changes
insert into CDCSample.WorkOrder
select WorkOrderID, ProductID, OrderQty, ScrappedQty, StartDate, EndDate, DueDate, ScrapReasonID, getdate()
from Production.WorkOrder
where  ModifiedDate >= '2004-07-18' and ModifiedDate < '2004-09-18'
go
-- Delay 10 seconds
waitfor delay '00:00:10'
go
